azure-odata-sql
Advanced tools
This library contains functionality to convert OData queries into SQL statements.
The library uses types from the mssql npm package to represent parameter types.
The query object is in the format produced by
azure-query-js.
npm i azure-odata-sql
The library currently exports a single function:
require('azure-odata-sql').format(query, tableConfig)
The query parameter is an object with any of the following properties:
| Property | Description |
|---|---|
| skip | Number of rows to skip |
| take | Number of rows to take |
| inlineCount | Set to allpages to include a total count query |
| resultLimit | Number of rows to limit the query to |
| selections | Columns to select |
| filters | Filters to apply |
| ordering | Columns to sort by |
| id | Record identifier |
| includeDeleted | Include soft deleted columns |
The tableConfig is an object with any of the following properties:
| Property | Description |
|---|---|
| name | The name of the table being queried |
| schema | The database schema name for the table |
| flavor | Either mssql or sqlite |
| softDelete | True if the table supports soft delete with a column called deleted |
FAQs
Convert OData queries into SQL statements
The npm package azure-odata-sql receives a total of 173 weekly downloads. As such, azure-odata-sql popularity was classified as not popular.
We found that azure-odata-sql demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
ENISA’s 2024 report highlights the EU’s top cybersecurity threats, including rising DDoS attacks, ransomware, supply chain vulnerabilities, and weaponized AI.
Security News
NIST's new password guidelines remove periodic changes and special character requirements, focusing on longer, more secure passwords for better authentication practices.
Security News
A record 2,709 developers participated in the 2024 Ruby on Rails Community Survey, revealing key tools, practices, and trends shaping the Rails ecosystem.